package com.coocaa.ops.plus.dashboard.v1.codegen.constant;

import lombok.experimental.UtilityClass;

/**
 * @author bijiahao
 * @description
 * @date 2020/1/2 17:48
 */
@UtilityClass
public class SqlConstants {

    public static final String DRIVER = "com.mysql.jdbc.Driver";

    public static final String TABLE_COUNT_QUERY_SQL = "select COUNT(1) from information_schema.`TABLES` where information_schema.`TABLES`.TABLE_SCHEMA = '%s'";
    public static final String TABLE_INFO_QUERY_SQL = "select TABLE_NAME AS NAME,TABLE_COMMENT AS COMMENT , CREATE_TIME from information_schema.`TABLES` where information_schema.`TABLES`.TABLE_SCHEMA = '%s'";

    public static final String[] SUPER_ENTITY_COLUMNS = new String[]{
            "flag",
            "creator",
            "created_date",
            "modifier",
            "last_update_date"
    };
    /**
     * 原始表的父类已包含的字段
     */
    public static final String[] SUPER_ENTITY_COLUMNS_ORIGIN_TABLE = new String[]{
            "status",
            "current_version",
            "duplicate_version",
    };

}
